package com.czc.cca.ddl;

import org.zoomdev.zoom.dao.ddl.SqlType;
import org.zoomdev.zoom.dao.ddl._DDL_Column;
import org.zoomdev.zoom.dao.ddl._DDL_Primary;
import org.zoomdev.zoom.dao.ddl._DDL_Table;
import org.zoomdev.zoom.dao.driver.mysql.MysqlDriver;

@_DDL_Table(name = "c_agent", simpleName = "", engine = MysqlDriver.InnoDB, comment = "渠道商")
public class _DDL_CAgent {

    @_DDL_Primary()
    @_DDL_Column(name = "id", type = SqlType.INT_UNSIGNED, nullable = false, comment = "渠道商id")
    private Long id;

    @_DDL_Column(name = "name", type = SqlType.VARCHAR, size = 100, nullable = false, comment = "机构名称")
    private String name;

    @_DDL_Column(name = "area_code", type = SqlType.VARCHAR, size = 10, nullable = false, comment = "区域代码")
    private String areaCode;

    @_DDL_Column(name = "area_name", type = SqlType.VARCHAR, size = 200, nullable = false, comment = "区域名称")
    private String areaName;

    @_DDL_Column(name = "concat_name", type = SqlType.VARCHAR, size = 100, nullable = false, comment = "经办人姓名")
    private String concatName;

    @_DDL_Column(name = "concat_phone", type = SqlType.VARCHAR, size = 20, nullable = false, comment = "经办人电话")
    private String concatPhone;

    @_DDL_Column(name = "concat_address", type = SqlType.VARCHAR, size = 200, comment = "商户地址")
    private String concatAddress;

    @_DDL_Column(name = "ch_id", type = SqlType.VARCHAR, size = 30, comment = "渠道商户id")
    private String chId;

    @_DDL_Column(name = "ch_type", type = SqlType.TINYINT_UNSIGNED, comment = "渠道类型 1：平安银行")
    private Integer chType;

    @_DDL_Column(name = "pro_id", type = SqlType.INT_UNSIGNED, comment = "协议id")
    private Long proId;

    @_DDL_Column(name = "pro_end_date", type = SqlType.VARCHAR, size = 10, comment = "协议结束日期")
    private String proEndDate;

    @_DDL_Column(name = "pro_begin_date", type = SqlType.VARCHAR, size = 10, comment = "协议开始日期")
    private String proBeginDate;

    @_DDL_Column(name = "pro_rate", type = SqlType.DECIMAL, size = 6, scale = 2, comment = "协议费率(万分之)")
    private java.math.BigDecimal proRate;

    @_DDL_Column(name = "pro_type", type = SqlType.VARCHAR, size = 1, comment = "类型")
    private String proType;

    @_DDL_Column(name = "pro_days", type = SqlType.TINYINT_UNSIGNED, comment = "t+n")
    private Integer proDays;

    @_DDL_Column(name = "pro_next_id", type = SqlType.INT_UNSIGNED, comment = "下一次签约")
    private Long proNextId;

    @_DDL_Column(name = "state", type = SqlType.VARCHAR, size = 10, comment = "状态")
    private String state;

    @_DDL_Column(name = "err_msg", type = SqlType.VARCHAR, size = 200, comment = "错误原因")
    private String errMsg;

    @_DDL_Column(name = "extra", type = SqlType.MEDIUMTEXT, comment = "额外数据")
    private String extra;

    @_DDL_Column(name = "cr_time", type = SqlType.TIMESTAMP, defaultFunction = MysqlDriver.CURRENT_TIMESTAMP, comment = "创建时间")
    private java.sql.Timestamp crTime;

    @_DDL_Column(name = "mer_id", type = SqlType.BIGINT_UNSIGNED, comment = "")
    private java.math.BigInteger merId;

}
